
create external table jms_ods.tab_forfeit_config
(ID  string COMMENT '主键ID',
FEE_TYPE string COMMENT '费用类型',
FEE_START_TIME TIMESTAMP COMMENT '罚款启用时间',
FEE_END_TIME TIMESTAMP COMMENT '罚款结束时间',
FEE_LEVEL string COMMENT '启罚点',
FEE_MONEY_PER DECIMAL(10,2) COMMENT '单笔金额(元)',
FEE_MONEY_UPPER DECIMAL(10,2) COMMENT '罚款上限',
FEE_MONEY_STATUS int COMMENT '罚款状态',
CREATE_BY_NAME string COMMENT '创建人名称',
CREATE_BY_CODE string COMMENT '创建人code',
CREATE_TIME TIMESTAMP COMMENT '创建时间',
UPDATE_TIME TIMESTAMP COMMENT '修改时间',
UPDATE_BY_NAME string COMMENT '修改人名称',
UPDATE_BY_CODE string COMMENT '修改人code',
REMARK string COMMENT '备注',
REMARK2 string COMMENT '预留字段'
)COMMENT '罚款配置表'
PARTITIONED BY (
  `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS parquet
LOCATION
  '/dw/hive/jms_ods.db/external/tab_forfeit_config';